

INSERT INTO cat_ranking
SELECT top 10
newid() AS [Id],sortorder AS [OrderNumber],[name] AS [Text],NULL AS [TextStyle],NULL AS [Count],NULL AS [NavigateUrl],1 AS [AreaCode],1 AS [IsPosted],NULL AS [Notes],getdate() AS [DateCreated],getdate() AS [LastUpdated],'00000000-0000-0000-0000-000000000053' AS [MobifiedBy]
from [cat_lov]
--where ParentId = '00000000-0000-0000-0000-000000201000'
where ParentId = '00000000-0000-0000-0000-000125030100'





